IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'EvaluationGetByID')
	BEGIN
		DROP  Procedure  EvaluationGetByID
	END

GO

CREATE Procedure EvaluationGetByID
(
	@EvaluationID int
)
AS

SELECT EvaluationID
	, EvaluationSourceID
	, RecommendationID
	, RatingTypeID
	, Description
	, URL
	, EvaluationDate
FROM Evaluations
WHERE EvaluationID = @EvaluationID
